package com.isoft.demooa.dao.employee;

import com.isoft.demooa.entity.employee.Normal;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface NormalMapper {

     @Select("select * from tb_employee order by id desc")
     List<Normal> selectAll();


     @Select("select * from tb_employee where id=#{id}")
     Normal selectById(Integer id);

     @Update("update tb_employee set name=#{name},gender=#{gender} where id=#{id}")
     Integer update(Normal normal);

     @Insert("insert into tb_employee(name,gender) value(#{name},#{gender})")
     Integer insert(Normal normal);
}
